Kelly Moore
Kelly Moore
-
Re: Absolute references in an Index Match formula
Hey @Celia Gust It seems the range of the {Portfolio Summary Header Row} reference might not have updated when the column order was changed . The purpose of the 2nd Match in the formula is to identif…1 · -
Re: Formula to populate a cell based on another cell's formula criteria
Hey @jromano Try this =INDEX(COLLECT(Trend:Trend, [Project Status]:[Project Status], [Project Status]1), COUNTIFS([Project Status]:[Project Status], [Project Status]1)) Will this work for you? Kelly1 · -
Re: Help with COUNTIFS Formula w/ multiple possible criteria in the same column
@PKane I’m glad this worked for you. I did wonder if your OR choices were the only choices (in your full list of choices) that had the phrase “Add temp cell” in the selection. If yes we could have us…1 · -
Re: Help with COUNTIFS Formula w/ multiple possible criteria in the same column
@PKane Try this: =COUNTIFS({Carrier Initiated TDM}, 1, {T1 to Temp Cell Status}, "In Progress", {T1 Scope}, OR(@cell = "Add Temp Cell", @cell = "Add temp cell, Disconnect&quo…1 · -
Re: Display most recent entry/value (by date and time) into a dashboard
Hello @kimkummer One approach is to add a helper column to your source sheet (a checkbox column will work. This is Sheet1) to flag the most recent date. You can push this column out of the way and hi…1 ·
